create procedure [dbo].[BAEEventSetupMoveFunctionUp] @eventCode varchar(16),
     @functionCode varchar(16),
     @groupName varchar(8) as
Declare @functionorder AS int;

    SELECT @functionorder =  FunctionOrder FROM EventSetupFunctionGroup WHERE EventCode = @eventCode AND GroupName = @groupName AND FunctionCode = @functionCode;
    
    if(@functionorder > 1)
    BEGIN
        /* Move Function Down */
        UPDATE EventSetupFunctionGroup
        SET FunctionOrder = FunctionOrder + 1
        WHERE EventCode = @eventCode  AND GroupName = @groupName AND FunctionOrder = @functionorder - 1;
        
        /* Move Function Up */
        UPDATE EventSetupFunctionGroup
        SET FunctionOrder = FunctionOrder - 1
        WHERE EventCode = @eventCode  AND FunctionCode = @functionCode
    END

GO